Be sure to set up a scheduled maintenance plan in SQL Server to reorganize and rebuild your iMIS database indexes on a routine basis, so that you have the best possible system performance. The larger the iMIS database, the more important this becomes in keeping performance up.
See MSDN to find out more about creating a maintenance plan. While every database is different and will have different requirements, a common routine is to reorganize your indexes daily and to rebuild them weekly.